Notes/Domino 6 and 7 Forum : as400 library list and stored procedure

We have an as400 db2 system using several libraries.

Library "X" contains the compiled pgms and stored procedures. "Y" contains the more dynamic tables of our db2 database. "Z" contains the more static/less dynamic tables of the db2 database.

We've created a web app using Notes 6 running on Domino on the as400.

We have a DB directory entry defined as "MCIC" *local. We have a user profile "ABC" defined which contains "X","Y","Z" as part of the library list.

We connect using this statement: conAS400.ConectTo('MCIC','ABC','password')

If we trigger an sql with an explicit reference to the library and filename, no problem. If we trigger an sql with no library explicitly specified, we get this error: "FILENAME in ABC type *FILE not Found." In other words the as400 library list means squat to Notes and Domino.

How do we apply the library list to a stored procedure being called from a notes agent?

Once called, will the stored procedure know the library list and be able to use it? Or do we need to code every file reference and sub-pgm call to a specific library and file or library and pgm? This task would be huge. And it sure is bloddy disconcerting to discover this at this stage of the game.

I guess, my question is, as far as the library list goes, where does notes end and as400 begin on a call to a stored procedure?

Any help on this would be greatly, greatly appreciated.

Thanks in advance,

Terry